<!-- 1903010328 查询通行证 -->
<?php
include "../../inc/log/adsession.php";
include "../../inc/data/connAdmin.php";
?>
<!doctype html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<title>学生管理首页</title>
	<link rel="stylesheet" type="text/css" href="/28/inc/CSS/admin">
	<link rel="stylesheet" type="text/css" href="/28/inc/CSS/reset.css">

</head>
<body>
	<div id="tScoreln">
		<!--顶部-->
			<div id="top">
			<img src="/28/inc/pic/00.png">
			<!--导航栏区域和下拉列表-->
			<div id="top-rig">
			<ul>
			    <li><a href="">首页</a></li>
			    <li id="ddown"><a href="" id="dropbtn">学校概况</a>
				    <div id="ddown-content">
				    <a href="">学校简介</a>
				    <a href="">历任教师</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">国际合作</a>
				    <div id="ddown-content">
				    <a href="">交流概况</a>
				    <a href="">国际学生</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">院系部门</a>
				    <div id="ddown-content">
				    <a href="">党群机构</a>
				    <a href="">管理与服务机构</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">科学研究</a>
				    <div id="ddown-content">
				    <a href="">科研概况</a>
				    <a href="">重点学科</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">教师队伍</a>
				    <div id="ddown-content">
				    <a href="">总体介绍</a>
				    <a href="">杰出人才</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">人才培养</a>
				    <div id="ddown-content">
				    <a href="">继续教育</a>
				    <a href="">奖贷学金</a>
				    </div>
				</li>
				<li id="ddown"><a href="" id="dropbtn">人才招聘</a>
				    <div id="ddown-content">
				    <a href="">优秀博士后</a>
				    <a href="">应聘方式</a>
				    </div>
				</li>
                <li id="ddown"><a href="" id="dropbtn">招生就业</a>
				    <div id="ddown-content">
				    <a href="">本科生招生</a>
				    <a href="">就业服务</a>
				    </div>
				</li>
				<img src="/28/inc/pic/find1.png">
		    </ul>
			</div>
			</div>
	    <!--顶部结束-->
	    <!---->
	    	<div id="main">
	        	<img src="/28/inc/pic/position.png">
	    		当前位置: 后台首页-学生管理
	    <!--结束-->
	    <div id="yh">
	    <img src="/28/inc/pic/user.png" style="width:25px;height:25px;margin:3px 10px;">
		<!-- 1903010328 动态信息 -->
		<h4 style="margin:8px 10px;font-size:20px;color:#1D50A2">您好！
		<?=$_SESSION["uName"]?>
		</h4>
	    </div>
	    <div id="SZ" style="">
	    	<ul style="font-size:20px;">
	    	<li id="" style="">
				<a href="../admin.php">后台首页</a></li>
				<li id="" style="">
				<a href="/28/admin/menu/menuAdmin.php">菜单管理</a></li>
				<li id="" style="">
				<a href="/28/admin/dep/depAdmin.php">二级学院管理</a></li>
				<li id="" style="">
				<a href="">教师管理</a></li>
				<li id="" style="">
				<a href="/28/admin/stu/stuAdmin.php">学生管理</a></li>
				<li id="" style="">
				<a href="/28/admin/cou/courseAdmin.php">课程管理</a></li>
				<li id="" style="">
				<a href="28/admin/course/taskAdmin.php">教学任务管理</a></li>
				<li id="" style="">
				<a href="/28/admin/adminQuit.php">注销</a></li>
				<li id="" style="">
				<a href="depAdd.php"><input type="button" value="添加二级学院" name="depname" style="width:100px;height:25px;background-color:#1eca1c;color:white"></a></li>
			</ul>
	    </div>
		<!--结束-->
	    <!--表格区域-->
	<div class="">
		<!-- 统计表 -->
			<table style="width:90%;margin:50px 80px;text-align:center;border:4px solid #1D50A2">
				<tr style="font-size:25px;color:#43a85e;height:30px;font-weight:bold;">
					<td>序号</td>
					<td>专业</td>
					<td>班级名称</td>
					<td>学生人数</td>
					<td>操作</td>
				</tr>
				<?php
		$sql = "select mamx_class.majorname,mamx_class.classname,count(mamx_class.classname) 
    			from mamx_stu,mamx_class,mamx_major
    			where mamx_stu.classname=mamx_class.classname
    			and mamx_class.majorname=mamx_major.majorname
    			group by mamx_class.classname";
  		$stmt = $conn -> prepare($sql);
 		$stmt -> execute();
  		$stmt -> bind_result($majorName,$stuClass,$ALLcount);
		$i = 1;
		while($stmt->fetch()){
		?>
			<tr style="font-size:18px;line-height:25px;font-weight:600">
			 <td><?=$i?></td>
      		<td><?=$majorName?></td>
      		<td><?=$stuClass?></td>
      		<td><?=$ALLcount?></td>
			<td><a href="stuShow.php? class=<?=$stuClass?>" style="color:#a25a1d;">查看班级学生</a>
			</td>

	</tr>
	<?php $i++;} ?>
			</table>
		</div>
		<!-- 1903010328导入学生区域 -->
	<form action="stuExImport.php" enctype="multipart/form-data" method="post" style="" >
  		<table  style="margin: 10px auto;border:4px solid #1D50A2" width="400px">
  			<tr>
				<td style="width:300px">
     				<input type="file" value="选择文件" name="stufile" style="width:300px;height:30px">
      			</td>
      			<td>
      				<input type="hidden" value="<?=$stuClass?>" name='classname'>
      				<input type="submit"  value="录入" style="width:100px;height:30px;background-color:#1D50A2;font-size:20px;text-align:center;color:white">
      			</td>
      		</tr>
  			<tr>
    			<td colspan="2" style="text-align:center">
   				<a href="../../inc/download/majorDown.xlsx"><input type="submit" value="下载模板" style="width:100px;height:30px;background-color:#1da252;font-size:20px;text-align:center;color:white"></a>
    			</td>
  			</tr>
  		</table>
	</form>
	</div>
</body>
</html>